Dataset statistics
| Number of variables | 34 |
|---|---|
| Number of observations | 142588 |
| Missing cells | 781636 |
| Missing cells (%) | 16.1% |
| Duplicate rows | 33 |
| Duplicate rows (%) | < 0.1% |
| Total size in memory | 37.0 MiB |
| Average record size in memory | 272.0 B |
Variable types
| Numeric | 7 |
|---|---|
| Boolean | 4 |
| Categorical | 12 |
| DateTime | 4 |
| Text | 6 |
| Unsupported | 1 |
| Dataset has 33 (< 0.1%) duplicate rows | Duplicates |
is highly overall correlated with business_name and 1 other fields | High correlation |
business_name is highly overall correlated with and 2 other fields | High correlation |
case_linked is highly overall correlated with business_name and 1 other fields | High correlation |
case_type is highly overall correlated with case_linked | High correlation |
customer_type is highly overall correlated with | High correlation |
day_of_month is highly overall correlated with month_period | High correlation |
month_period is highly overall correlated with day_of_month | High correlation |
referred is highly overall correlated with business_name | High correlation |
total_cxl_appointments_before_appointment is highly overall correlated with total_good_appointments_before_appointment | High correlation |
total_good_appointments_before_appointment is highly overall correlated with total_cxl_appointments_before_appointment | High correlation |
patient_status is highly imbalanced (81.3%) | Imbalance |
patient_type is highly imbalanced (62.1%) | Imbalance |
missed is highly imbalanced (89.4%) | Imbalance |
title is highly imbalanced (54.8%) | Imbalance |
sex is highly imbalanced (63.6%) | Imbalance |
case_type has 61949 (43.4%) missing values | Missing |
next_appointment_time has 116141 (81.5%) missing values | Missing |
cancelled_at has 119696 (83.9%) missing values | Missing |
billable_item has 3942 (2.8%) missing values | Missing |
category has 24476 (17.2%) missing values | Missing |
customer_type has 103758 (72.8%) missing values | Missing |
title has 58854 (41.3%) missing values | Missing |
state has 71910 (50.4%) missing values | Missing |
date_of_birth has 2578 (1.8%) missing values | Missing |
sex has 49112 (34.4%) missing values | Missing |
post_code has 51112 (35.8%) missing values | Missing |
city has 49994 (35.1%) missing values | Missing |
occupation has 68082 (47.7%) missing values | Missing |
post_code is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
total_open_invoices_before_appointemnt has 133150 (93.4%) zeros | Zeros |
total_good_appointments_before_appointment has 15297 (10.7%) zeros | Zeros |
total_cxl_appointments_before_appointment has 87748 (61.5%) zeros | Zeros |
notice has 119702 (83.9%) zeros | Zeros |
Reproduction
| Analysis started | 2024-06-09 11:06:47.030382 |
|---|---|
| Analysis finished | 2024-06-09 11:07:48.681626 |
| Duration | 1 minute and 1.65 second |
| Software version | ydata-profiling v4.8.3 |
| Download configuration | config.json |
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.531125 |
| Minimum | 2 |
|---|---|
| Maximum | 16 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 12 |
| Q1 | 12 |
| median | 13 |
| Q3 | 16 |
| 95-th percentile | 16 |
| Maximum | 16 |
| Range | 14 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 1.8397643 |
|---|---|
| Coefficient of variation (CV) | 0.13596536 |
| Kurtosis | -1.4498233 |
| Mean | 13.531125 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.45622436 |
| Sum | 1929376 |
| Variance | 3.3847326 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 12 | 57664 | |
| 16 | 48654 | |
| 13 | 29681 | |
| 11 | 6410 | 4.5% |
| 15 | 171 | 0.1% |
| 2 | 8 | < 0.1% |
| Value | Count | Frequency (%) |
| 2 | 8 | < 0.1% |
| 11 | 6410 | 4.5% |
| 12 | 57664 | |
| 13 | 29681 | |
| 15 | 171 | 0.1% |
| 16 | 48654 |
| Value | Count | Frequency (%) |
| 16 | 48654 | |
| 15 | 171 | 0.1% |
| 13 | 29681 | |
| 12 | 57664 | |
| 11 | 6410 | 4.5% |
| 2 | 8 | < 0.1% |
case_linked
Boolean
HIGH CORRELATION 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 139.4 KiB |
| True | |
|---|---|
| False |
| Value | Count | Frequency (%) |
| True | 80639 | |
| False | 61949 |
case_type
Categorical
HIGH CORRELATION  MISSING 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 61949 |
| Missing (%) | 43.4% |
| Memory size | 1.1 MiB |
| Unlimited | |
|---|---|
| Max Sessions | |
| Max Amount | 104 |
Length
| Max length | 12 |
|---|---|
| Median length | 9 |
| Mean length | 9.7887623 |
| Min length | 9 |
Characters and Unicode
| Total characters | 789356 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Unlimited |
|---|---|
| 2nd row | Unlimited |
| 3rd row | Unlimited |
| 4th row | Unlimited |
| 5th row | Unlimited |
Common Values
| Value | Count | Frequency (%) |
| Unlimited | 59368 | |
| Max Sessions | 21167 | 14.8% |
| Max Amount | 104 | 0.1% |
| (Missing) | 61949 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| unlimited | 59368 | |
| max | 21271 | 20.9% |
| sessions | 21167 | 20.8% |
| amount | 104 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 139903 | |
| n | 80639 | |
| e | 80535 | |
| s | 63501 | |
| m | 59472 | |
| t | 59472 | |
| U | 59368 | |
| l | 59368 | |
| d | 59368 | |
| 21271 | 2.7% | |
| Other values (7) | 106459 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 789356 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| i | 139903 | |
| n | 80639 | |
| e | 80535 | |
| s | 63501 | |
| m | 59472 | |
| t | 59472 | |
| U | 59368 | |
| l | 59368 | |
| d | 59368 | |
| 21271 | 2.7% | |
| Other values (7) | 106459 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 789356 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| i | 139903 | |
| n | 80639 | |
| e | 80535 | |
| s | 63501 | |
| m | 59472 | |
| t | 59472 | |
| U | 59368 | |
| l | 59368 | |
| d | 59368 | |
| 21271 | 2.7% | |
| Other values (7) | 106459 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 789356 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| i | 139903 | |
| n | 80639 | |
| e | 80535 | |
| s | 63501 | |
| m | 59472 | |
| t | 59472 | |
| U | 59368 | |
| l | 59368 | |
| d | 59368 | |
| 21271 | 2.7% | |
| Other values (7) | 106459 |
total_open_invoices_before_appointemnt
Real number (ℝ)
ZEROS 
| Distinct | 37 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.15844251 |
| Minimum | 0 |
|---|---|
| Maximum | 36 |
| Zeros | 133150 |
| Zeros (%) | 93.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 36 |
| Range | 36 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.89940366 |
|---|---|
| Coefficient of variation (CV) | 5.6765302 |
| Kurtosis | 236.06917 |
| Mean | 0.15844251 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 12.036222 |
| Sum | 22592 |
| Variance | 0.80892695 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 133150 | |
| 1 | 4897 | 3.4% |
| 2 | 1966 | 1.4% |
| 3 | 933 | 0.7% |
| 4 | 597 | 0.4% |
| 5 | 267 | 0.2% |
| 6 | 179 | 0.1% |
| 7 | 159 | 0.1% |
| 9 | 120 | 0.1% |
| 8 | 92 | 0.1% |
| Other values (27) | 228 | 0.2% |
| Value | Count | Frequency (%) |
| 0 | 133150 | |
| 1 | 4897 | 3.4% |
| 2 | 1966 | 1.4% |
| 3 | 933 | 0.7% |
| 4 | 597 | 0.4% |
| 5 | 267 | 0.2% |
| 6 | 179 | 0.1% |
| 7 | 159 | 0.1% |
| 8 | 92 | 0.1% |
| 9 | 120 | 0.1% |
| Value | Count | Frequency (%) |
| 36 | 1 | |
| 35 | 1 | |
| 34 | 1 | |
| 33 | 1 | |
| 32 | 1 | |
| 31 | 1 | |
| 30 | 1 | |
| 29 | 1 | |
| 28 | 1 | |
| 27 | 2 |
total_good_appointments_before_appointment
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 335 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10.58918 |
| Minimum | 0 |
|---|---|
| Maximum | 334 |
| Zeros | 15297 |
| Zeros (%) | 10.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 3 |
| Q3 | 10 |
| 95-th percentile | 45 |
| Maximum | 334 |
| Range | 334 |
| Interquartile range (IQR) | 9 |
Descriptive statistics
| Standard deviation | 23.449078 |
|---|---|
| Coefficient of variation (CV) | 2.2144375 |
| Kurtosis | 44.197321 |
| Mean | 10.58918 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 5.7101934 |
| Sum | 1509890 |
| Variance | 549.85924 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 32620 | |
| 0 | 15297 | |
| 2 | 13329 | 9.3% |
| 3 | 10798 | 7.6% |
| 4 | 8875 | 6.2% |
| 5 | 7313 | 5.1% |
| 6 | 5940 | 4.2% |
| 7 | 4888 | 3.4% |
| 8 | 4146 | 2.9% |
| 9 | 3541 | 2.5% |
| Other values (325) | 35841 |
| Value | Count | Frequency (%) |
| 0 | 15297 | |
| 1 | 32620 | |
| 2 | 13329 | |
| 3 | 10798 | 7.6% |
| 4 | 8875 | 6.2% |
| 5 | 7313 | 5.1% |
| 6 | 5940 | 4.2% |
| 7 | 4888 | 3.4% |
| 8 | 4146 | 2.9% |
| 9 | 3541 | 2.5% |
| Value | Count | Frequency (%) |
| 334 | 1 | |
| 333 | 1 | |
| 332 | 1 | |
| 331 | 1 | |
| 330 | 1 | |
| 329 | 1 | |
| 328 | 1 | |
| 327 | 1 | |
| 326 | 1 | |
| 325 | 1 |
total_cxl_appointments_before_appointment
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 134 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.6344924 |
| Minimum | 0 |
|---|---|
| Maximum | 145 |
| Zeros | 87748 |
| Zeros (%) | 61.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 2 |
| 95-th percentile | 13 |
| Maximum | 145 |
| Range | 145 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 8.6717357 |
|---|---|
| Coefficient of variation (CV) | 3.2916154 |
| Kurtosis | 76.642096 |
| Mean | 2.6344924 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 7.4385572 |
| Sum | 375647 |
| Variance | 75.199 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 87748 | |
| 1 | 19022 | 13.3% |
| 2 | 8624 | 6.0% |
| 3 | 5195 | 3.6% |
| 4 | 3739 | 2.6% |
| 5 | 2731 | 1.9% |
| 6 | 2069 | 1.5% |
| 7 | 1472 | 1.0% |
| 8 | 1220 | 0.9% |
| 9 | 1155 | 0.8% |
| Other values (124) | 9613 | 6.7% |
| Value | Count | Frequency (%) |
| 0 | 87748 | |
| 1 | 19022 | 13.3% |
| 2 | 8624 | 6.0% |
| 3 | 5195 | 3.6% |
| 4 | 3739 | 2.6% |
| 5 | 2731 | 1.9% |
| 6 | 2069 | 1.5% |
| 7 | 1472 | 1.0% |
| 8 | 1220 | 0.9% |
| 9 | 1155 | 0.8% |
| Value | Count | Frequency (%) |
| 145 | 22 | |
| 144 | 12 | |
| 143 | 22 | |
| 142 | 1 | < 0.1% |
| 141 | 2 | < 0.1% |
| 140 | 3 | < 0.1% |
| 139 | 2 | < 0.1% |
| 138 | 3 | < 0.1% |
| 137 | 1 | < 0.1% |
| 136 | 3 | < 0.1% |
patient_status
Categorical
IMBALANCE 
| Distinct | 10 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| Not Yet Actioned | |
|---|---|
| Therapist Follow Up | 7366 |
| Has An Upcoming Booking | 2191 |
| Patient Stopped Treatment | 1694 |
| Admin Follow Up | 850 |
| Other values (5) | 937 |
Length
| Max length | 25 |
|---|---|
| Median length | 16 |
| Mean length | 16.380516 |
| Min length | 14 |
Characters and Unicode
| Total characters | 2335665 |
|---|---|
| Distinct characters | 37 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Not Yet Actioned |
|---|---|
| 2nd row | Not Yet Actioned |
| 3rd row | Not Yet Actioned |
| 4th row | Not Yet Actioned |
| 5th row | Not Yet Actioned |
Common Values
| Value | Count | Frequency (%) |
| Not Yet Actioned | 129550 | |
| Therapist Follow Up | 7366 | 5.2% |
| Has An Upcoming Booking | 2191 | 1.5% |
| Patient Stopped Treatment | 1694 | 1.2% |
| Admin Follow Up | 850 | 0.6% |
| Discharged By Therapist | 352 | 0.2% |
| On Waiting List | 322 | 0.2% |
| Staff & Family | 126 | 0.1% |
| Contacted Too Many Times | 81 | 0.1% |
| Do Not Contact | 56 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| not | 129606 | |
| actioned | 129550 | |
| yet | 129550 | |
| follow | 8216 | 1.9% |
| up | 8216 | 1.9% |
| therapist | 7718 | 1.8% |
| has | 2191 | 0.5% |
| an | 2191 | 0.5% |
| upcoming | 2191 | 0.5% |
| booking | 2191 | 0.5% |
| Other values (18) | 8416 | 2.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 405938 | |
| 287448 | ||
| o | 284210 | |
| e | 274108 | |
| i | 145719 | 6.2% |
| n | 141223 | 6.0% |
| A | 132591 | 5.7% |
| d | 132527 | 5.7% |
| c | 132230 | 5.7% |
| N | 129606 | 5.5% |
| Other values (27) | 270065 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2335665 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| t | 405938 | |
| 287448 | ||
| o | 284210 | |
| e | 274108 | |
| i | 145719 | 6.2% |
| n | 141223 | 6.0% |
| A | 132591 | 5.7% |
| d | 132527 | 5.7% |
| c | 132230 | 5.7% |
| N | 129606 | 5.5% |
| Other values (27) | 270065 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2335665 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| t | 405938 | |
| 287448 | ||
| o | 284210 | |
| e | 274108 | |
| i | 145719 | 6.2% |
| n | 141223 | 6.0% |
| A | 132591 | 5.7% |
| d | 132527 | 5.7% |
| c | 132230 | 5.7% |
| N | 129606 | 5.5% |
| Other values (27) | 270065 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2335665 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| t | 405938 | |
| 287448 | ||
| o | 284210 | |
| e | 274108 | |
| i | 145719 | 6.2% |
| n | 141223 | 6.0% |
| A | 132591 | 5.7% |
| d | 132527 | 5.7% |
| c | 132230 | 5.7% |
| N | 129606 | 5.5% |
| Other values (27) | 270065 |
patient_type
Categorical
IMBALANCE 
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| Recurring | |
|---|---|
| new injury/issue | |
| New To Clinic | 6249 |
| new to therapist | 3908 |
| new to service | 461 |
Length
| Max length | 16 |
|---|---|
| Median length | 9 |
| Mean length | 9.9809241 |
| Min length | 9 |
Characters and Unicode
| Total characters | 1423160 |
|---|---|
| Distinct characters | 24 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | New To Clinic |
|---|---|
| 2nd row | Recurring |
| 3rd row | Recurring |
| 4th row | Recurring |
| 5th row | New To Clinic |
Common Values
| Value | Count | Frequency (%) |
| Recurring | 119797 | |
| new injury/issue | 12173 | 8.5% |
| New To Clinic | 6249 | 4.4% |
| new to therapist | 3908 | 2.7% |
| new to service | 461 | 0.3% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| recurring | 119797 | |
| new | 22791 | 12.9% |
| injury/issue | 12173 | 6.9% |
| to | 10618 | 6.0% |
| clinic | 6249 | 3.6% |
| therapist | 3908 | 2.2% |
| service | 461 | 0.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 256136 | |
| i | 161010 | |
| e | 159591 | |
| n | 154761 | |
| u | 144143 | |
| c | 126507 | |
| R | 119797 | |
| g | 119797 | |
| 33409 | 2.3% | |
| s | 28715 | 2.0% |
| Other values (14) | 119294 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1423160 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| r | 256136 | |
| i | 161010 | |
| e | 159591 | |
| n | 154761 | |
| u | 144143 | |
| c | 126507 | |
| R | 119797 | |
| g | 119797 | |
| 33409 | 2.3% | |
| s | 28715 | 2.0% |
| Other values (14) | 119294 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1423160 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| r | 256136 | |
| i | 161010 | |
| e | 159591 | |
| n | 154761 | |
| u | 144143 | |
| c | 126507 | |
| R | 119797 | |
| g | 119797 | |
| 33409 | 2.3% | |
| s | 28715 | 2.0% |
| Other values (14) | 119294 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1423160 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| r | 256136 | |
| i | 161010 | |
| e | 159591 | |
| n | 154761 | |
| u | 144143 | |
| c | 126507 | |
| R | 119797 | |
| g | 119797 | |
| 33409 | 2.3% | |
| s | 28715 | 2.0% |
| Other values (14) | 119294 |
time_of_day
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| Late Afternoon | |
|---|---|
| Late Morning | |
| Early Morning | |
| Evening |
Length
| Max length | 14 |
|---|---|
| Median length | 13 |
| Mean length | 12.749067 |
| Min length | 7 |
Characters and Unicode
| Total characters | 1817864 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Early Morning |
|---|---|
| 2nd row | Late Afternoon |
| 3rd row | Late Morning |
| 4th row | Late Morning |
| 5th row | Early Morning |
Common Values
| Value | Count | Frequency (%) |
| Late Afternoon | 68696 | |
| Late Morning | 50404 | |
| Early Morning | 14476 | 10.2% |
| Evening | 9012 | 6.3% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| late | 119100 | |
| afternoon | 68696 | |
| morning | 64880 | |
| early | 14476 | 5.2% |
| evening | 9012 | 3.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 285176 | |
| o | 202272 | |
| e | 196808 | |
| t | 187796 | |
| r | 148052 | |
| 133576 | ||
| a | 133576 | |
| L | 119100 | |
| i | 73892 | 4.1% |
| g | 73892 | 4.1% |
| Other values (7) | 263724 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1817864 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| n | 285176 | |
| o | 202272 | |
| e | 196808 | |
| t | 187796 | |
| r | 148052 | |
| 133576 | ||
| a | 133576 | |
| L | 119100 | |
| i | 73892 | 4.1% |
| g | 73892 | 4.1% |
| Other values (7) | 263724 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1817864 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| n | 285176 | |
| o | 202272 | |
| e | 196808 | |
| t | 187796 | |
| r | 148052 | |
| 133576 | ||
| a | 133576 | |
| L | 119100 | |
| i | 73892 | 4.1% |
| g | 73892 | 4.1% |
| Other values (7) | 263724 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1817864 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| n | 285176 | |
| o | 202272 | |
| e | 196808 | |
| t | 187796 | |
| r | 148052 | |
| 133576 | ||
| a | 133576 | |
| L | 119100 | |
| i | 73892 | 4.1% |
| g | 73892 | 4.1% |
| Other values (7) | 263724 |
month_period
Categorical
HIGH CORRELATION 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| Mid month | |
|---|---|
| End month | |
| Early month |
Length
| Max length | 11 |
|---|---|
| Median length | 9 |
| Mean length | 9.6488765 |
| Min length | 9 |
Characters and Unicode
| Total characters | 1375814 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Mid month |
|---|---|
| 2nd row | Mid month |
| 3rd row | Mid month |
| 4th row | Mid month |
| 5th row | End month |
Common Values
| Value | Count | Frequency (%) |
| Mid month | 49458 | |
| End month | 46869 | |
| Early month | 46261 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| month | 142588 | |
| mid | 49458 | 17.3% |
| end | 46869 | 16.4% |
| early | 46261 | 16.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 189457 | |
| 142588 | ||
| m | 142588 | |
| o | 142588 | |
| t | 142588 | |
| h | 142588 | |
| d | 96327 | |
| E | 93130 | |
| M | 49458 | 3.6% |
| i | 49458 | 3.6% |
| Other values (4) | 185044 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1375814 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| n | 189457 | |
| 142588 | ||
| m | 142588 | |
| o | 142588 | |
| t | 142588 | |
| h | 142588 | |
| d | 96327 | |
| E | 93130 | |
| M | 49458 | 3.6% |
| i | 49458 | 3.6% |
| Other values (4) | 185044 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1375814 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| n | 189457 | |
| 142588 | ||
| m | 142588 | |
| o | 142588 | |
| t | 142588 | |
| h | 142588 | |
| d | 96327 | |
| E | 93130 | |
| M | 49458 | 3.6% |
| i | 49458 | 3.6% |
| Other values (4) | 185044 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1375814 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| n | 189457 | |
| 142588 | ||
| m | 142588 | |
| o | 142588 | |
| t | 142588 | |
| h | 142588 | |
| d | 96327 | |
| E | 93130 | |
| M | 49458 | 3.6% |
| i | 49458 | 3.6% |
| Other values (4) | 185044 |
day_of_week
Categorical
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 8 |
| Missing (%) | < 0.1% |
| Memory size | 1.1 MiB |
| Thursday | |
|---|---|
| Tuesday | |
| Wednesday | |
| Monday | |
| Friday | |
| Other values (2) |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 9 |
| Min length | 9 |
Characters and Unicode
| Total characters | 1283220 |
|---|---|
| Distinct characters | 18 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Friday |
|---|---|
| 2nd row | Thursday |
| 3rd row | Thursday |
| 4th row | Friday |
| 5th row | Monday |
Common Values
| Value | Count | Frequency (%) |
| Thursday | 29586 | |
| Tuesday | 27986 | |
| Wednesday | 27877 | |
| Monday | 24398 | |
| Friday | 24219 | |
| Saturday | 7958 | 5.6% |
| Sunday | 556 | 0.4% |
| (Missing) | 8 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| thursday | 29586 | |
| tuesday | 27986 | |
| wednesday | 27877 | |
| monday | 24398 | |
| friday | 24219 | |
| saturday | 7958 | 5.6% |
| sunday | 556 | 0.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| 241035 | ||
| d | 170457 | |
| a | 150538 | |
| y | 142580 | |
| s | 85449 | 6.7% |
| e | 83740 | 6.5% |
| u | 66086 | 5.2% |
| r | 61763 | 4.8% |
| T | 57572 | 4.5% |
| n | 52831 | 4.1% |
| Other values (8) | 171169 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1283220 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 241035 | ||
| d | 170457 | |
| a | 150538 | |
| y | 142580 | |
| s | 85449 | 6.7% |
| e | 83740 | 6.5% |
| u | 66086 | 5.2% |
| r | 61763 | 4.8% |
| T | 57572 | 4.5% |
| n | 52831 | 4.1% |
| Other values (8) | 171169 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1283220 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 241035 | ||
| d | 170457 | |
| a | 150538 | |
| y | 142580 | |
| s | 85449 | 6.7% |
| e | 83740 | 6.5% |
| u | 66086 | 5.2% |
| r | 61763 | 4.8% |
| T | 57572 | 4.5% |
| n | 52831 | 4.1% |
| Other values (8) | 171169 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1283220 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 241035 | ||
| d | 170457 | |
| a | 150538 | |
| y | 142580 | |
| s | 85449 | 6.7% |
| e | 83740 | 6.5% |
| u | 66086 | 5.2% |
| r | 61763 | 4.8% |
| T | 57572 | 4.5% |
| n | 52831 | 4.1% |
| Other values (8) | 171169 |
month_of_year
Categorical
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 8 |
| Missing (%) | < 0.1% |
| Memory size | 1.1 MiB |
| May | |
|---|---|
| March | |
| February | |
| June | |
| April | |
| Other values (7) |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 9 |
| Min length | 9 |
Characters and Unicode
| Total characters | 1283220 |
|---|---|
| Distinct characters | 27 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | July |
|---|---|
| 2nd row | August |
| 3rd row | August |
| 4th row | September |
| 5th row | September |
Common Values
| Value | Count | Frequency (%) |
| May | 15437 | |
| March | 14400 | |
| February | 13293 | |
| June | 13225 | |
| April | 12850 | |
| November | 12360 | |
| January | 12343 | |
| December | 10663 | |
| July | 9976 | |
| October | 9622 | |
| Other values (2) | 18411 |
Length
| Value | Count | Frequency (%) |
| may | 15437 | |
| march | 14400 | |
| february | 13293 | |
| june | 13225 | |
| april | 12850 | |
| november | 12360 | |
| january | 12343 | |
| december | 10663 | |
| july | 9976 | |
| october | 9622 | |
| Other values (2) | 18411 |
Most occurring characters
| Value | Count | Frequency (%) |
| 426589 | ||
| e | 119366 | 9.3% |
| r | 107663 | 8.4% |
| u | 67981 | 5.3% |
| a | 67816 | 5.3% |
| b | 54777 | 4.3% |
| y | 51049 | 4.0% |
| J | 35544 | 2.8% |
| c | 34685 | 2.7% |
| m | 31862 | 2.5% |
| Other values (17) | 285888 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1283220 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 426589 | ||
| e | 119366 | 9.3% |
| r | 107663 | 8.4% |
| u | 67981 | 5.3% |
| a | 67816 | 5.3% |
| b | 54777 | 4.3% |
| y | 51049 | 4.0% |
| J | 35544 | 2.8% |
| c | 34685 | 2.7% |
| m | 31862 | 2.5% |
| Other values (17) | 285888 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1283220 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 426589 | ||
| e | 119366 | 9.3% |
| r | 107663 | 8.4% |
| u | 67981 | 5.3% |
| a | 67816 | 5.3% |
| b | 54777 | 4.3% |
| y | 51049 | 4.0% |
| J | 35544 | 2.8% |
| c | 34685 | 2.7% |
| m | 31862 | 2.5% |
| Other values (17) | 285888 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1283220 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 426589 | ||
| e | 119366 | 9.3% |
| r | 107663 | 8.4% |
| u | 67981 | 5.3% |
| a | 67816 | 5.3% |
| b | 54777 | 4.3% |
| y | 51049 | 4.0% |
| J | 35544 | 2.8% |
| c | 34685 | 2.7% |
| m | 31862 | 2.5% |
| Other values (17) | 285888 |
day_of_month
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 31 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 8 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.621911 |
| Minimum | 1 |
|---|---|
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 8 |
| median | 16 |
| Q3 | 23 |
| 95-th percentile | 29 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 8.6304372 |
|---|---|
| Coefficient of variation (CV) | 0.55245722 |
| Kurtosis | -1.1425088 |
| Mean | 15.621911 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | 0.031020007 |
| Sum | 2227372 |
| Variance | 74.484447 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 15 | 5282 | 3.7% |
| 20 | 5142 | 3.6% |
| 13 | 5108 | 3.6% |
| 22 | 5045 | 3.5% |
| 8 | 5008 | 3.5% |
| 16 | 4960 | 3.5% |
| 14 | 4955 | 3.5% |
| 9 | 4886 | 3.4% |
| 19 | 4868 | 3.4% |
| 11 | 4834 | 3.4% |
| Other values (21) | 92492 |
| Value | Count | Frequency (%) |
| 1 | 4287 | |
| 2 | 4307 | |
| 3 | 4529 | |
| 4 | 4740 | |
| 5 | 4682 | |
| 6 | 4820 | |
| 7 | 4634 | |
| 8 | 5008 | |
| 9 | 4886 | |
| 10 | 4368 |
| Value | Count | Frequency (%) |
| 31 | 2597 | |
| 30 | 3998 | |
| 29 | 4335 | |
| 28 | 4434 | |
| 27 | 4715 | |
| 26 | 3792 | |
| 25 | 3844 | |
| 24 | 4466 | |
| 23 | 4811 | |
| 22 | 5045 |
week_of_year
Real number (ℝ)
| Distinct | 53 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 8 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 24.938708 |
| Minimum | 1 |
|---|---|
| Maximum | 53 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 12 |
| median | 23 |
| Q3 | 38 |
| 95-th percentile | 49 |
| Maximum | 53 |
| Range | 52 |
| Interquartile range (IQR) | 26 |
Descriptive statistics
| Standard deviation | 14.939851 |
|---|---|
| Coefficient of variation (CV) | 0.59906273 |
| Kurtosis | -1.1778436 |
| Mean | 24.938708 |
| Median Absolute Deviation (MAD) | 13 |
| Skewness | 0.20220916 |
| Sum | 3555761 |
| Variance | 223.19913 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 22 | 3688 | 2.6% |
| 12 | 3505 | 2.5% |
| 20 | 3477 | 2.4% |
| 19 | 3431 | 2.4% |
| 23 | 3419 | 2.4% |
| 18 | 3366 | 2.4% |
| 10 | 3365 | 2.4% |
| 21 | 3359 | 2.4% |
| 6 | 3287 | 2.3% |
| 8 | 3257 | 2.3% |
| Other values (43) | 108426 |
| Value | Count | Frequency (%) |
| 1 | 1820 | |
| 2 | 3111 | |
| 3 | 3201 | |
| 4 | 2755 | |
| 5 | 3253 | |
| 6 | 3287 | |
| 7 | 3209 | |
| 8 | 3257 | |
| 9 | 3201 | |
| 10 | 3365 |
| Value | Count | Frequency (%) |
| 53 | 69 | < 0.1% |
| 52 | 724 | 0.5% |
| 51 | 3016 | |
| 50 | 3133 | |
| 49 | 2978 | |
| 48 | 2970 | |
| 47 | 3011 | |
| 46 | 3107 | |
| 45 | 2624 | |
| 44 | 2324 |
appointment_status
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| Not Rebooked | |
|---|---|
| Rebooked |
Length
| Max length | 12 |
|---|---|
| Median length | 12 |
| Mean length | 11.258086 |
| Min length | 8 |
Characters and Unicode
| Total characters | 1605268 |
|---|---|
| Distinct characters | 9 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Not Rebooked |
|---|---|
| 2nd row | Not Rebooked |
| 3rd row | Not Rebooked |
| 4th row | Not Rebooked |
| 5th row | Not Rebooked |
Common Values
| Value | Count | Frequency (%) |
| Not Rebooked | 116141 | |
| Rebooked | 26447 | 18.5% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| rebooked | 142588 | |
| not | 116141 |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 401317 | |
| e | 285176 | |
| R | 142588 | 8.9% |
| b | 142588 | 8.9% |
| k | 142588 | 8.9% |
| d | 142588 | 8.9% |
| N | 116141 | 7.2% |
| t | 116141 | 7.2% |
| 116141 | 7.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1605268 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| o | 401317 | |
| e | 285176 | |
| R | 142588 | 8.9% |
| b | 142588 | 8.9% |
| k | 142588 | 8.9% |
| d | 142588 | 8.9% |
| N | 116141 | 7.2% |
| t | 116141 | 7.2% |
| 116141 | 7.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1605268 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| o | 401317 | |
| e | 285176 | |
| R | 142588 | 8.9% |
| b | 142588 | 8.9% |
| k | 142588 | 8.9% |
| d | 142588 | 8.9% |
| N | 116141 | 7.2% |
| t | 116141 | 7.2% |
| 116141 | 7.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1605268 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| o | 401317 | |
| e | 285176 | |
| R | 142588 | 8.9% |
| b | 142588 | 8.9% |
| k | 142588 | 8.9% |
| d | 142588 | 8.9% |
| N | 116141 | 7.2% |
| t | 116141 | 7.2% |
| 116141 | 7.2% |
MISSING 
| Distinct | 13826 |
|---|---|
| Distinct (%) | 52.3% |
| Missing | 116141 |
| Missing (%) | 81.5% |
| Memory size | 1.1 MiB |
| Minimum | 2020-10-26 10:00:00 |
|---|---|
| Maximum | 2026-01-01 09:30:00 |
notice
Real number (ℝ)
ZEROS 
| Distinct | 14995 |
|---|---|
| Distinct (%) | 10.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -841.51892 |
| Minimum | -65869.14 |
|---|---|
| Maximum | 17186.2 |
| Zeros | 119702 |
| Zeros (%) | 83.9% |
| Negative | 7672 |
| Negative (%) | 5.4% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | -65869.14 |
|---|---|
| 5-th percentile | -1042.24 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 27.1265 |
| Maximum | 17186.2 |
| Range | 83055.34 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 4682.9759 |
|---|---|
| Coefficient of variation (CV) | -5.5649086 |
| Kurtosis | 64.831787 |
| Mean | -841.51892 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -7.2020881 |
| Sum | -1.199905 × 108 |
| Variance | 21930263 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 119702 | |
| 23.58 | 16 | < 0.1% |
| 23.68 | 15 | < 0.1% |
| 22.79 | 14 | < 0.1% |
| 1.76 | 14 | < 0.1% |
| 23.27 | 14 | < 0.1% |
| 23.86 | 13 | < 0.1% |
| 1.77 | 13 | < 0.1% |
| 23.42 | 13 | < 0.1% |
| 23.48 | 13 | < 0.1% |
| Other values (14985) | 22761 | 16.0% |
| Value | Count | Frequency (%) |
| -65869.14 | 1 | |
| -65863.14 | 1 | |
| -65692.14 | 1 | |
| -65578.64 | 1 | |
| -65482.64 | 1 | |
| -65476.14 | 1 | |
| -65142.64 | 1 | |
| -65020.64 | 1 | |
| -64684.14 | 1 | |
| -63829.14 | 1 |
| Value | Count | Frequency (%) |
| 17186.2 | 1 | |
| 16850.2 | 1 | |
| 16514.2 | 1 | |
| 16178.2 | 1 | |
| 15842.2 | 1 | |
| 15506.2 | 1 | |
| 15170.2 | 1 | |
| 14834.2 | 1 | |
| 14498.2 | 1 | |
| 14162.2 | 1 |
cancelled_at
Date
MISSING 
| Distinct | 15540 |
|---|---|
| Distinct (%) | 67.9% |
| Missing | 119696 |
| Missing (%) | 83.9% |
| Memory size | 1.1 MiB |
| Minimum | 2020-07-16 08:36:13+00:00 |
|---|---|
| Maximum | 2024-06-08 02:48:31+00:00 |
appointment_type
Text
| Distinct | 580 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
Length
| Max length | 125 |
|---|---|
| Median length | 98 |
| Mean length | 46.628188 |
| Min length | 4 |
Characters and Unicode
| Total characters | 6648620 |
|---|---|
| Distinct characters | 85 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 87 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | ✅20 Minute Follow Up Consult |
|---|---|
| 2nd row | ✅20 Minute Follow Up Consult |
| 3rd row | ✅20 Minute Follow Up Consult |
| 4th row | ✅20 Minute Follow Up Consult |
| 5th row | ✅20 Minute Follow Up Consult |
| Value | Count | Frequency (%) |
| 115294 | 11.9% | |
| subsequent | 64724 | 6.7% |
| consultation | 63100 | 6.5% |
| consult | 61333 | 6.3% |
| 2 | 51540 | 5.3% |
| up | 49287 | 5.1% |
| follow | 49211 | 5.1% |
| minute | 44288 | 4.6% |
| physiotherapy | 37332 | 3.8% |
| 30 | 28483 | 2.9% |
| Other values (384) | 405940 |
Most occurring characters
| Value | Count | Frequency (%) |
| 833188 | 12.5% | |
| t | 527489 | 7.9% |
| o | 463384 | 7.0% |
| n | 434612 | 6.5% |
| e | 428083 | 6.4% |
| i | 366282 | 5.5% |
| s | 362839 | 5.5% |
| u | 328294 | 4.9% |
| l | 309964 | 4.7% |
| a | 278059 | 4.2% |
| Other values (75) | 2316426 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 6648620 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 833188 | 12.5% | |
| t | 527489 | 7.9% |
| o | 463384 | 7.0% |
| n | 434612 | 6.5% |
| e | 428083 | 6.4% |
| i | 366282 | 5.5% |
| s | 362839 | 5.5% |
| u | 328294 | 4.9% |
| l | 309964 | 4.7% |
| a | 278059 | 4.2% |
| Other values (75) | 2316426 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 6648620 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 833188 | 12.5% | |
| t | 527489 | 7.9% |
| o | 463384 | 7.0% |
| n | 434612 | 6.5% |
| e | 428083 | 6.4% |
| i | 366282 | 5.5% |
| s | 362839 | 5.5% |
| u | 328294 | 4.9% |
| l | 309964 | 4.7% |
| a | 278059 | 4.2% |
| Other values (75) | 2316426 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 6648620 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 833188 | 12.5% | |
| t | 527489 | 7.9% |
| o | 463384 | 7.0% |
| n | 434612 | 6.5% |
| e | 428083 | 6.4% |
| i | 366282 | 5.5% |
| s | 362839 | 5.5% |
| u | 328294 | 4.9% |
| l | 309964 | 4.7% |
| a | 278059 | 4.2% |
| Other values (75) | 2316426 |
billable_item
Text
MISSING 
| Distinct | 427 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 3942 |
| Missing (%) | 2.8% |
| Memory size | 1.1 MiB |
Length
| Max length | 125 |
|---|---|
| Median length | 102 |
| Mean length | 44.604648 |
| Min length | 11 |
Characters and Unicode
| Total characters | 6184256 |
|---|---|
| Distinct characters | 73 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 48 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | PhysioCall - 20 Minute Follow Up Consult (Pre-paid) |
|---|---|
| 2nd row | PhysioCall - 20 Minute Follow Up Consult (Pre-paid) |
| 3rd row | PhysioCall - 20 Minute Follow Up Consult (Pre-paid) |
| 4th row | PhysioCall - 20 Minute Follow Up Consult (Pre-paid) |
| 5th row | PhysioCall - 20 Minute Follow Up Consult (Pre-paid) |
| Value | Count | Frequency (%) |
| 117300 | 13.7% | |
| subsequent | 64758 | 7.6% |
| consultation | 62269 | 7.3% |
| consult | 59582 | 7.0% |
| up | 47246 | 5.5% |
| follow | 47046 | 5.5% |
| osteopathy | 43367 | 5.1% |
| minute | 42426 | 5.0% |
| physiotherapy | 35882 | 4.2% |
| 30 | 29428 | 3.4% |
| Other values (286) | 307635 |
Most occurring characters
| Value | Count | Frequency (%) |
| 739173 | 12.0% | |
| t | 516423 | 8.4% |
| o | 453326 | 7.3% |
| n | 426036 | 6.9% |
| e | 403064 | 6.5% |
| i | 359012 | 5.8% |
| s | 358798 | 5.8% |
| u | 322138 | 5.2% |
| l | 308684 | 5.0% |
| a | 274125 | 4.4% |
| Other values (63) | 2023477 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 6184256 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 739173 | 12.0% | |
| t | 516423 | 8.4% |
| o | 453326 | 7.3% |
| n | 426036 | 6.9% |
| e | 403064 | 6.5% |
| i | 359012 | 5.8% |
| s | 358798 | 5.8% |
| u | 322138 | 5.2% |
| l | 308684 | 5.0% |
| a | 274125 | 4.4% |
| Other values (63) | 2023477 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 6184256 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 739173 | 12.0% | |
| t | 516423 | 8.4% |
| o | 453326 | 7.3% |
| n | 426036 | 6.9% |
| e | 403064 | 6.5% |
| i | 359012 | 5.8% |
| s | 358798 | 5.8% |
| u | 322138 | 5.2% |
| l | 308684 | 5.0% |
| a | 274125 | 4.4% |
| Other values (63) | 2023477 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 6184256 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 739173 | 12.0% | |
| t | 516423 | 8.4% |
| o | 453326 | 7.3% |
| n | 426036 | 6.9% |
| e | 403064 | 6.5% |
| i | 359012 | 5.8% |
| s | 358798 | 5.8% |
| u | 322138 | 5.2% |
| l | 308684 | 5.0% |
| a | 274125 | 4.4% |
| Other values (63) | 2023477 |
category
Text
MISSING 
| Distinct | 161 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 24476 |
| Missing (%) | 17.2% |
| Memory size | 1.1 MiB |
Length
| Max length | 68 |
|---|---|
| Median length | 62 |
| Mean length | 34.101751 |
| Min length | 3 |
Characters and Unicode
| Total characters | 4027826 |
|---|---|
| Distinct characters | 91 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 18 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | A | Pre Pay Online & Save ✅ |
|---|---|
| 2nd row | A | Pre Pay Online & Save ✅ |
| 3rd row | A | Pre Pay Online & Save ✅ |
| 4th row | A | Pre Pay Online & Save ✅ |
| 5th row | A | Pre Pay Online & Save ✅ |
| Value | Count | Frequency (%) |
| 71336 | 11.8% | |
| 2 | 42860 | 7.1% |
| subsequent | 37632 | 6.2% |
| consultations | 37277 | 6.2% |
| for | 37115 | 6.1% |
| osteopathy | 36551 | 6.0% |
| existing | 35938 | 5.9% |
| patients | 35938 | 5.9% |
| physiotherapy | 27515 | 4.5% |
| a | 26225 | 4.3% |
| Other values (205) | 216406 |
Most occurring characters
| Value | Count | Frequency (%) |
| 488300 | 12.1% | |
| t | 330438 | 8.2% |
| s | 285905 | 7.1% |
| e | 231211 | 5.7% |
| n | 213718 | 5.3% |
| o | 192977 | 4.8% |
| i | 191787 | 4.8% |
| a | 177585 | 4.4% |
| P | 130288 | 3.2% |
| u | 126705 | 3.1% |
| Other values (81) | 1658912 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4027826 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 488300 | 12.1% | |
| t | 330438 | 8.2% |
| s | 285905 | 7.1% |
| e | 231211 | 5.7% |
| n | 213718 | 5.3% |
| o | 192977 | 4.8% |
| i | 191787 | 4.8% |
| a | 177585 | 4.4% |
| P | 130288 | 3.2% |
| u | 126705 | 3.1% |
| Other values (81) | 1658912 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4027826 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 488300 | 12.1% | |
| t | 330438 | 8.2% |
| s | 285905 | 7.1% |
| e | 231211 | 5.7% |
| n | 213718 | 5.3% |
| o | 192977 | 4.8% |
| i | 191787 | 4.8% |
| a | 177585 | 4.4% |
| P | 130288 | 3.2% |
| u | 126705 | 3.1% |
| Other values (81) | 1658912 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4027826 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 488300 | 12.1% | |
| t | 330438 | 8.2% |
| s | 285905 | 7.1% |
| e | 231211 | 5.7% |
| n | 213718 | 5.3% |
| o | 192977 | 4.8% |
| i | 191787 | 4.8% |
| a | 177585 | 4.4% |
| P | 130288 | 3.2% |
| u | 126705 | 3.1% |
| Other values (81) | 1658912 |
cancelled
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 139.4 KiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 119696 | |
| True | 22892 | 16.1% |
missed
Boolean
IMBALANCE 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 139.4 KiB |
| False | |
|---|---|
| True | 1982 |
| Value | Count | Frequency (%) |
| False | 140606 | |
| True | 1982 | 1.4% |
| Distinct | 62819 |
|---|---|
| Distinct (%) | 44.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| Minimum | 2009-08-15 01:30:00+00:00 |
|---|---|
| Maximum | 2025-12-31 23:30:00+00:00 |
business_name
Categorical
HIGH CORRELATION 
| Distinct | 25 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| Scarb Physio & Health | |
|---|---|
| All Sorted Physiotherapy | |
| Osteopathy | Melton | |
| Osteopathy | Bacchus Marsh | |
| Scarb Remedial Massage | |
| Other values (20) |
Length
| Max length | 30 |
|---|---|
| Median length | 26 |
| Mean length | 21.578597 |
| Min length | 12 |
Characters and Unicode
| Total characters | 3076849 |
|---|---|
| Distinct characters | 47 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | PhysioCall Gladstone |
|---|---|
| 2nd row | PhysioCall Gladstone |
| 3rd row | PhysioCall Gladstone |
| 4th row | PhysioCall Gladstone |
| 5th row | PhysioCall Gladstone |
Common Values
| Value | Count | Frequency (%) |
| Scarb Physio & Health | 32219 | |
| All Sorted Physiotherapy | 29681 | |
| Osteopathy | Melton | 26974 | |
| Osteopathy | Bacchus Marsh | 17735 | |
| Scarb Remedial Massage | 8732 | 6.1% |
| PhysioCall Gladstone | 6252 | 4.4% |
| Bosch Psychology | 5753 | 4.0% |
| Newport Physiotherapy | 5153 | 3.6% |
| Newport Psychology | 4207 | 3.0% |
| Physiotherapy | Melton | 1407 | 1.0% |
| Other values (15) | 4475 | 3.1% |
Length
| Value | Count | Frequency (%) |
| 80527 | ||
| osteopathy | 44709 | |
| scarb | 41897 | |
| physiotherapy | 36410 | |
| health | 32873 | |
| physio | 32219 | 7.0% |
| all | 29681 | 6.5% |
| sorted | 29681 | 6.5% |
| melton | 29331 | 6.4% |
| bacchus | 18375 | 4.0% |
| Other values (25) | 81710 |
Most occurring characters
| Value | Count | Frequency (%) |
| 314825 | 10.2% | |
| h | 242304 | 7.9% |
| a | 235913 | 7.7% |
| t | 235743 | 7.7% |
| o | 225274 | 7.3% |
| e | 218725 | 7.1% |
| s | 202344 | 6.6% |
| y | 177814 | 5.8% |
| l | 161340 | 5.2% |
| r | 137624 | 4.5% |
| Other values (37) | 924943 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3076849 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 314825 | 10.2% | |
| h | 242304 | 7.9% |
| a | 235913 | 7.7% |
| t | 235743 | 7.7% |
| o | 225274 | 7.3% |
| e | 218725 | 7.1% |
| s | 202344 | 6.6% |
| y | 177814 | 5.8% |
| l | 161340 | 5.2% |
| r | 137624 | 4.5% |
| Other values (37) | 924943 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3076849 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 314825 | 10.2% | |
| h | 242304 | 7.9% |
| a | 235913 | 7.7% |
| t | 235743 | 7.7% |
| o | 225274 | 7.3% |
| e | 218725 | 7.1% |
| s | 202344 | 6.6% |
| y | 177814 | 5.8% |
| l | 161340 | 5.2% |
| r | 137624 | 4.5% |
| Other values (37) | 924943 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3076849 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 314825 | 10.2% | |
| h | 242304 | 7.9% |
| a | 235913 | 7.7% |
| t | 235743 | 7.7% |
| o | 225274 | 7.3% |
| e | 218725 | 7.1% |
| s | 202344 | 6.6% |
| y | 177814 | 5.8% |
| l | 161340 | 5.2% |
| r | 137624 | 4.5% |
| Other values (37) | 924943 |
customer_type
Categorical
HIGH CORRELATION  MISSING 
| Distinct | 35 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 103758 |
| Missing (%) | 72.8% |
| Memory size | 1.1 MiB |
| WorkCover | |
|---|---|
| NDIS | |
| Concession / Pension Card Holder | |
| Medicare Referrals | |
| DVA | |
| Other values (30) |
Length
| Max length | 32 |
|---|---|
| Median length | 23 |
| Mean length | 12.327221 |
| Min length | 3 |
Characters and Unicode
| Total characters | 478666 |
|---|---|
| Distinct characters | 46 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Staff |
|---|---|
| 2nd row | Staff |
| 3rd row | High Risk |
| 4th row | High Risk |
| 5th row | Staff |
Common Values
| Value | Count | Frequency (%) |
| WorkCover | 5945 | 4.2% |
| NDIS | 5638 | 4.0% |
| Concession / Pension Card Holder | 5346 | 3.7% |
| Medicare Referrals | 4281 | 3.0% |
| DVA | 3120 | 2.2% |
| NDIS Customer | 2474 | 1.7% |
| CDM | 2449 | 1.7% |
| DVA Card Holder | 2188 | 1.5% |
| Third Party | 1716 | 1.2% |
| Student | 1531 | 1.1% |
| Other values (25) | 4142 | 2.9% |
| (Missing) | 103758 |
Length
| Value | Count | Frequency (%) |
| ndis | 8112 | |
| card | 7538 | |
| holder | 7534 | |
| workcover | 6158 | |
| 5923 | 7.7% | |
| medicare | 5621 | 7.3% |
| concession | 5408 | 7.1% |
| pension | 5346 | 7.0% |
| dva | 5308 | 6.9% |
| referrals | 4281 | 5.6% |
| Other values (37) | 15375 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 50709 | 10.6% |
| r | 49464 | 10.3% |
| o | 39555 | 8.3% |
| 38209 | 8.0% | |
| d | 24831 | 5.2% |
| C | 24721 | 5.2% |
| n | 24050 | 5.0% |
| s | 24023 | 5.0% |
| a | 21273 | 4.4% |
| i | 19786 | 4.1% |
| Other values (36) | 162045 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 478666 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 50709 | 10.6% |
| r | 49464 | 10.3% |
| o | 39555 | 8.3% |
| 38209 | 8.0% | |
| d | 24831 | 5.2% |
| C | 24721 | 5.2% |
| n | 24050 | 5.0% |
| s | 24023 | 5.0% |
| a | 21273 | 4.4% |
| i | 19786 | 4.1% |
| Other values (36) | 162045 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 478666 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 50709 | 10.6% |
| r | 49464 | 10.3% |
| o | 39555 | 8.3% |
| 38209 | 8.0% | |
| d | 24831 | 5.2% |
| C | 24721 | 5.2% |
| n | 24050 | 5.0% |
| s | 24023 | 5.0% |
| a | 21273 | 4.4% |
| i | 19786 | 4.1% |
| Other values (36) | 162045 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 478666 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 50709 | 10.6% |
| r | 49464 | 10.3% |
| o | 39555 | 8.3% |
| 38209 | 8.0% | |
| d | 24831 | 5.2% |
| C | 24721 | 5.2% |
| n | 24050 | 5.0% |
| s | 24023 | 5.0% |
| a | 21273 | 4.4% |
| i | 19786 | 4.1% |
| Other values (36) | 162045 |
title
Categorical
IMBALANCE  MISSING 
| Distinct | 33 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 58854 |
| Missing (%) | 41.3% |
| Memory size | 1.1 MiB |
| Mr | |
|---|---|
| Mrs | |
| Ms | |
| Miss | |
| Master | 1545 |
| Other values (28) |
Length
| Max length | 15 |
|---|---|
| Median length | 2 |
| Mean length | 2.5610027 |
| Min length | 1 |
Characters and Unicode
| Total characters | 214443 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 8 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Mr |
|---|---|
| 2nd row | Mr |
| 3rd row | Miss |
| 4th row | Mr |
| 5th row | Miss |
Common Values
| Value | Count | Frequency (%) |
| Mr | 31422 | |
| Mrs | 21231 | 14.9% |
| Ms | 17166 | 12.0% |
| Miss | 8307 | 5.8% |
| Master | 1545 | 1.1% |
| 1470 | 1.0% | |
| MISS | 928 | 0.7% |
| Dr | 681 | 0.5% |
| MASTER | 355 | 0.2% |
| Mrs | 185 | 0.1% |
| Other values (23) | 444 | 0.3% |
| (Missing) | 58854 |
Length
| Value | Count | Frequency (%) |
| mr | 31635 | |
| mrs | 21417 | |
| ms | 17236 | |
| miss | 9241 | 11.2% |
| master | 1900 | 2.3% |
| dr | 681 | 0.8% |
| mast | 70 | 0.1% |
| maste | 22 | < 0.1% |
| mx | 17 | < 0.1% |
| sr | 10 | < 0.1% |
| Other values (9) | 32 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| M | 81536 | |
| s | 56920 | |
| r | 55286 | |
| i | 8317 | 3.9% |
| S | 2225 | 1.0% |
| 2153 | 1.0% | |
| a | 1651 | 0.8% |
| t | 1645 | 0.8% |
| e | 1580 | 0.7% |
| I | 928 | 0.4% |
| Other values (16) | 2202 | 1.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 214443 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| M | 81536 | |
| s | 56920 | |
| r | 55286 | |
| i | 8317 | 3.9% |
| S | 2225 | 1.0% |
| 2153 | 1.0% | |
| a | 1651 | 0.8% |
| t | 1645 | 0.8% |
| e | 1580 | 0.7% |
| I | 928 | 0.4% |
| Other values (16) | 2202 | 1.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 214443 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| M | 81536 | |
| s | 56920 | |
| r | 55286 | |
| i | 8317 | 3.9% |
| S | 2225 | 1.0% |
| 2153 | 1.0% | |
| a | 1651 | 0.8% |
| t | 1645 | 0.8% |
| e | 1580 | 0.7% |
| I | 928 | 0.4% |
| Other values (16) | 2202 | 1.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 214443 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| M | 81536 | |
| s | 56920 | |
| r | 55286 | |
| i | 8317 | 3.9% |
| S | 2225 | 1.0% |
| 2153 | 1.0% | |
| a | 1651 | 0.8% |
| t | 1645 | 0.8% |
| e | 1580 | 0.7% |
| I | 928 | 0.4% |
| Other values (16) | 2202 | 1.0% |
state
Text
MISSING 
| Distinct | 74 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 71910 |
| Missing (%) | 50.4% |
| Memory size | 1.1 MiB |
Length
| Max length | 17 |
|---|---|
| Median length | 3 |
| Mean length | 3.1782026 |
| Min length | 1 |
Characters and Unicode
| Total characters | 224629 |
|---|---|
| Distinct characters | 56 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 12 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | QLD |
|---|---|
| 2nd row | QLD |
| 3rd row | QLD |
| 4th row | QLD |
| 5th row | QLD |
| Value | Count | Frequency (%) |
| qld | 61584 | |
| vic | 6462 | 9.1% |
| queensland | 1293 | 1.8% |
| nsw | 785 | 1.1% |
| west | 155 | 0.2% |
| gladstone | 153 | 0.2% |
| victoria | 107 | 0.2% |
| wa | 47 | 0.1% |
| newport | 22 | < 0.1% |
| sa | 19 | < 0.1% |
| Other values (55) | 247 | 0.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| Q | 62791 | |
| L | 58100 | |
| D | 58081 | |
| V | 6567 | 2.9% |
| I | 5603 | 2.5% |
| C | 5448 | 2.4% |
| d | 5014 | 2.2% |
| l | 5008 | 2.2% |
| e | 2993 | 1.3% |
| n | 2820 | 1.3% |
| Other values (46) | 12204 | 5.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 224629 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| Q | 62791 | |
| L | 58100 | |
| D | 58081 | |
| V | 6567 | 2.9% |
| I | 5603 | 2.5% |
| C | 5448 | 2.4% |
| d | 5014 | 2.2% |
| l | 5008 | 2.2% |
| e | 2993 | 1.3% |
| n | 2820 | 1.3% |
| Other values (46) | 12204 | 5.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 224629 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| Q | 62791 | |
| L | 58100 | |
| D | 58081 | |
| V | 6567 | 2.9% |
| I | 5603 | 2.5% |
| C | 5448 | 2.4% |
| d | 5014 | 2.2% |
| l | 5008 | 2.2% |
| e | 2993 | 1.3% |
| n | 2820 | 1.3% |
| Other values (46) | 12204 | 5.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 224629 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| Q | 62791 | |
| L | 58100 | |
| D | 58081 | |
| V | 6567 | 2.9% |
| I | 5603 | 2.5% |
| C | 5448 | 2.4% |
| d | 5014 | 2.2% |
| l | 5008 | 2.2% |
| e | 2993 | 1.3% |
| n | 2820 | 1.3% |
| Other values (46) | 12204 | 5.4% |
date_of_birth
Date
MISSING 
| Distinct | 18931 |
|---|---|
| Distinct (%) | 13.5% |
| Missing | 2578 |
| Missing (%) | 1.8% |
| Memory size | 1.1 MiB |
| Minimum | 1904-01-19 00:00:00 |
|---|---|
| Maximum | 2024-04-22 00:00:00 |
sex
Categorical
IMBALANCE  MISSING 
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 49112 |
| Missing (%) | 34.4% |
| Memory size | 1.1 MiB |
| Female | |
|---|---|
| Male | |
| 9 | 1405 |
| female | 152 |
| male | 143 |
| Other values (3) | 26 |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 5.1750931 |
| Min length | 1 |
Characters and Unicode
| Total characters | 483747 |
|---|---|
| Distinct characters | 15 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Male |
|---|---|
| 2nd row | Male |
| 3rd row | Male |
| 4th row | Male |
| 5th row | Male |
Common Values
| Value | Count | Frequency (%) |
| Female | 56870 | |
| Male | 34880 | |
| 9 | 1405 | 1.0% |
| female | 152 | 0.1% |
| male | 143 | 0.1% |
| Other | 13 | < 0.1% |
| AMAB | 12 | < 0.1% |
| other | 1 | < 0.1% |
| (Missing) | 49112 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| female | 57022 | |
| male | 35023 | |
| 9 | 1405 | 1.5% |
| other | 14 | < 0.1% |
| amab | 12 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 149081 | |
| a | 92045 | |
| l | 92045 | |
| m | 57165 | 11.8% |
| F | 56870 | 11.8% |
| M | 34892 | 7.2% |
| 9 | 1405 | 0.3% |
| f | 152 | < 0.1% |
| A | 24 | < 0.1% |
| t | 14 | < 0.1% |
| Other values (5) | 54 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 483747 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 149081 | |
| a | 92045 | |
| l | 92045 | |
| m | 57165 | 11.8% |
| F | 56870 | 11.8% |
| M | 34892 | 7.2% |
| 9 | 1405 | 0.3% |
| f | 152 | < 0.1% |
| A | 24 | < 0.1% |
| t | 14 | < 0.1% |
| Other values (5) | 54 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 483747 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 149081 | |
| a | 92045 | |
| l | 92045 | |
| m | 57165 | 11.8% |
| F | 56870 | 11.8% |
| M | 34892 | 7.2% |
| 9 | 1405 | 0.3% |
| f | 152 | < 0.1% |
| A | 24 | < 0.1% |
| t | 14 | < 0.1% |
| Other values (5) | 54 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 483747 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 149081 | |
| a | 92045 | |
| l | 92045 | |
| m | 57165 | 11.8% |
| F | 56870 | 11.8% |
| M | 34892 | 7.2% |
| 9 | 1405 | 0.3% |
| f | 152 | < 0.1% |
| A | 24 | < 0.1% |
| t | 14 | < 0.1% |
| Other values (5) | 54 | < 0.1% |
post_code
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 51112 |
|---|---|
| Missing (%) | 35.8% |
| Memory size | 1.1 MiB |
city
Text
MISSING 
| Distinct | 901 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 49994 |
| Missing (%) | 35.1% |
| Memory size | 1.1 MiB |
Length
| Max length | 43 |
|---|---|
| Median length | 25 |
| Mean length | 9.4585826 |
| Min length | 2 |
Characters and Unicode
| Total characters | 875808 |
|---|---|
| Distinct characters | 69 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 170 ? |
|---|---|
| Unique (%) | 0.2% |
Sample
| 1st row | South Gladstone |
|---|---|
| 2nd row | Clinton |
| 3rd row | Gladstone |
| 4th row | South Gladstone |
| 5th row | Toolooa |
| Value | Count | Frequency (%) |
| scarborough | 17321 | 15.4% |
| gladstone | 16019 | 14.3% |
| newport | 8419 | 7.5% |
| redcliffe | 7433 | 6.6% |
| margate | 3798 | 3.4% |
| clontarf | 2991 | 2.7% |
| bay | 2570 | 2.3% |
| deception | 2523 | 2.2% |
| kippa | 2198 | 2.0% |
| ring | 2198 | 2.0% |
| Other values (627) | 46856 |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 64155 | 7.3% |
| r | 56642 | 6.5% |
| a | 48844 | 5.6% |
| e | 48273 | 5.5% |
| S | 37112 | 4.2% |
| N | 36826 | 4.2% |
| c | 28424 | 3.2% |
| t | 27851 | 3.2% |
| l | 27652 | 3.2% |
| A | 27031 | 3.1% |
| Other values (59) | 472998 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 875808 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| o | 64155 | 7.3% |
| r | 56642 | 6.5% |
| a | 48844 | 5.6% |
| e | 48273 | 5.5% |
| S | 37112 | 4.2% |
| N | 36826 | 4.2% |
| c | 28424 | 3.2% |
| t | 27851 | 3.2% |
| l | 27652 | 3.2% |
| A | 27031 | 3.1% |
| Other values (59) | 472998 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 875808 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| o | 64155 | 7.3% |
| r | 56642 | 6.5% |
| a | 48844 | 5.6% |
| e | 48273 | 5.5% |
| S | 37112 | 4.2% |
| N | 36826 | 4.2% |
| c | 28424 | 3.2% |
| t | 27851 | 3.2% |
| l | 27652 | 3.2% |
| A | 27031 | 3.1% |
| Other values (59) | 472998 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 875808 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| o | 64155 | 7.3% |
| r | 56642 | 6.5% |
| a | 48844 | 5.6% |
| e | 48273 | 5.5% |
| S | 37112 | 4.2% |
| N | 36826 | 4.2% |
| c | 28424 | 3.2% |
| t | 27851 | 3.2% |
| l | 27652 | 3.2% |
| A | 27031 | 3.1% |
| Other values (59) | 472998 |
occupation
Text
MISSING 
| Distinct | 3868 |
|---|---|
| Distinct (%) | 5.2% |
| Missing | 68082 |
| Missing (%) | 47.7% |
| Memory size | 1.1 MiB |
Length
| Max length | 57 |
|---|---|
| Median length | 45 |
| Mean length | 11.767549 |
| Min length | 1 |
Characters and Unicode
| Total characters | 876753 |
|---|---|
| Distinct characters | 80 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1322 ? |
|---|---|
| Unique (%) | 1.8% |
Sample
| 1st row | Physio |
|---|---|
| 2nd row | Remedial massage therapist |
| 3rd row | QAL Operator |
| 4th row | Physio |
| 5th row | Student |
| Value | Count | Frequency (%) |
| retired | 14268 | 12.2% |
| student | 5763 | 4.9% |
| manager | 4207 | 3.6% |
| teacher | 3681 | 3.1% |
| worker | 2161 | 1.8% |
| nurse | 2001 | 1.7% |
| officer | 1833 | 1.6% |
| assistant | 1816 | 1.6% |
| driver | 1562 | 1.3% |
| support | 1432 | 1.2% |
| Other values (2083) | 78373 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 117204 | |
| r | 85633 | 9.8% |
| t | 74321 | 8.5% |
| i | 66308 | 7.6% |
| a | 55452 | 6.3% |
| n | 50426 | 5.8% |
| 44914 | 5.1% | |
| o | 38126 | 4.3% |
| d | 36019 | 4.1% |
| s | 35166 | 4.0% |
| Other values (70) | 273184 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 876753 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 117204 | |
| r | 85633 | 9.8% |
| t | 74321 | 8.5% |
| i | 66308 | 7.6% |
| a | 55452 | 6.3% |
| n | 50426 | 5.8% |
| 44914 | 5.1% | |
| o | 38126 | 4.3% |
| d | 36019 | 4.1% |
| s | 35166 | 4.0% |
| Other values (70) | 273184 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 876753 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 117204 | |
| r | 85633 | 9.8% |
| t | 74321 | 8.5% |
| i | 66308 | 7.6% |
| a | 55452 | 6.3% |
| n | 50426 | 5.8% |
| 44914 | 5.1% | |
| o | 38126 | 4.3% |
| d | 36019 | 4.1% |
| s | 35166 | 4.0% |
| Other values (70) | 273184 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 876753 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 117204 | |
| r | 85633 | 9.8% |
| t | 74321 | 8.5% |
| i | 66308 | 7.6% |
| a | 55452 | 6.3% |
| n | 50426 | 5.8% |
| 44914 | 5.1% | |
| o | 38126 | 4.3% |
| d | 36019 | 4.1% |
| s | 35166 | 4.0% |
| Other values (70) | 273184 |
referred
Boolean
HIGH CORRELATION 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 139.4 KiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 97591 | |
| True | 44997 |
| appointment_status | business_name | cancelled | case_linked | case_type | customer_type | day_of_month | day_of_week | missed | month_of_year | month_period | notice | patient_status | patient_type | referred | sex | time_of_day | title | total_cxl_appointments_before_appointment | total_good_appointments_before_appointment | total_open_invoices_before_appointemnt | week_of_year | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1.000 | 0.105 | 1.000 | 0.183 | 0.147 | 0.191 | 0.787 | 0.002 | 0.128 | 0.021 | 0.107 | 0.011 | -0.127 | 0.071 | 0.149 | 0.400 | 0.059 | 0.126 | 0.222 | -0.255 | -0.197 | -0.095 | -0.009 | |
| appointment_status | 0.105 | 1.000 | 0.325 | 0.016 | 0.286 | 0.022 | 0.445 | 0.000 | 0.061 | 0.016 | 0.040 | 0.000 | 0.096 | 0.196 | 0.138 | 0.121 | 0.085 | 0.083 | 0.101 | 0.279 | 0.368 | 0.261 | -0.017 |
| business_name | 1.000 | 0.325 | 1.000 | 0.223 | 0.673 | 0.306 | 0.325 | -0.002 | 0.113 | 0.042 | 0.066 | 0.020 | 0.259 | 0.118 | 0.160 | 0.671 | 0.107 | 0.180 | 0.121 | -0.048 | 0.064 | 0.080 | -0.036 |
| cancelled | 0.183 | 0.016 | 0.223 | 1.000 | 0.104 | 0.061 | 0.114 | -0.003 | 0.024 | 0.052 | 0.018 | 0.001 | 0.328 | 0.019 | 0.182 | 0.000 | 0.052 | 0.054 | 0.079 | 0.278 | 0.041 | 0.026 | 0.004 |
| case_linked | 0.147 | 0.286 | 0.673 | 0.104 | 1.000 | 1.000 | 0.352 | -0.001 | 0.093 | 0.032 | 0.096 | 0.000 | 0.180 | 0.201 | 0.083 | 0.443 | 0.185 | 0.145 | 0.245 | 0.123 | 0.331 | 0.128 | -0.078 |
| case_type | 0.191 | 0.022 | 0.306 | 0.061 | 1.000 | 1.000 | 0.342 | -0.005 | 0.068 | 0.031 | 0.033 | 0.004 | 0.064 | 0.037 | 0.040 | 0.128 | 0.031 | 0.069 | 0.050 | 0.028 | 0.058 | 0.005 | -0.017 |
| customer_type | 0.787 | 0.445 | 0.325 | 0.114 | 0.352 | 0.342 | 1.000 | 0.002 | 0.117 | 0.063 | 0.055 | 0.012 | -0.028 | 0.162 | 0.132 | 0.436 | 0.182 | 0.190 | 0.189 | 0.110 | 0.191 | 0.280 | -0.023 |
| day_of_month | 0.002 | 0.000 | -0.002 | -0.003 | -0.001 | -0.005 | 0.002 | 1.000 | 0.035 | 0.004 | 0.073 | 0.964 | 0.003 | 0.003 | 0.007 | 0.006 | 0.001 | 0.005 | 0.000 | -0.005 | -0.005 | 0.008 | 0.050 |
| day_of_week | 0.128 | 0.061 | 0.113 | 0.024 | 0.093 | 0.068 | 0.117 | 0.035 | 1.000 | 0.006 | 0.027 | 0.031 | 0.012 | 0.015 | 0.063 | 0.074 | 0.023 | 0.137 | 0.034 | 0.020 | 0.038 | 0.006 | -0.017 |
| missed | 0.021 | 0.016 | 0.042 | 0.052 | 0.032 | 0.031 | 0.063 | 0.004 | 0.006 | 1.000 | 0.023 | 0.000 | -0.017 | 0.026 | 0.044 | 0.020 | 0.038 | 0.007 | 0.035 | 0.014 | 0.020 | 0.029 | -0.002 |
| month_of_year | 0.107 | 0.040 | 0.066 | 0.018 | 0.096 | 0.033 | 0.055 | 0.073 | 0.027 | 0.023 | 1.000 | 0.078 | -0.027 | 0.056 | 0.045 | 0.051 | 0.013 | 0.010 | 0.021 | 0.012 | -0.017 | -0.009 | 0.308 |
| month_period | 0.011 | 0.000 | 0.020 | 0.001 | 0.000 | 0.004 | 0.012 | 0.964 | 0.031 | 0.000 | 0.078 | 1.000 | -0.002 | 0.004 | 0.006 | 0.001 | 0.000 | 0.000 | 0.000 | -0.001 | -0.002 | -0.001 | 0.035 |
| notice | -0.127 | 0.096 | 0.259 | 0.328 | 0.180 | 0.064 | -0.028 | 0.003 | 0.012 | -0.017 | -0.027 | -0.002 | 1.000 | 0.023 | 0.079 | 0.133 | 0.021 | 0.042 | 0.072 | -0.139 | 0.023 | 0.048 | -0.033 |
| patient_status | 0.071 | 0.196 | 0.118 | 0.019 | 0.201 | 0.037 | 0.162 | 0.003 | 0.015 | 0.026 | 0.056 | 0.004 | 0.023 | 1.000 | 0.045 | 0.128 | 0.031 | 0.028 | 0.044 | 0.080 | 0.096 | -0.012 | -0.065 |
| patient_type | 0.149 | 0.138 | 0.160 | 0.182 | 0.083 | 0.040 | 0.132 | 0.007 | 0.063 | 0.044 | 0.045 | 0.006 | 0.079 | 0.045 | 1.000 | 0.084 | 0.027 | 0.122 | 0.048 | -0.055 | -0.035 | -0.027 | 0.023 |
| referred | 0.400 | 0.121 | 0.671 | 0.000 | 0.443 | 0.128 | 0.436 | 0.006 | 0.074 | 0.020 | 0.051 | 0.001 | 0.133 | 0.128 | 0.084 | 1.000 | 0.123 | 0.154 | 0.215 | 0.071 | 0.106 | 0.031 | -0.021 |
| sex | 0.059 | 0.085 | 0.107 | 0.052 | 0.185 | 0.031 | 0.182 | 0.001 | 0.023 | 0.038 | 0.013 | 0.000 | 0.021 | 0.031 | 0.027 | 0.123 | 1.000 | 0.049 | 0.442 | -0.069 | 0.003 | 0.067 | -0.011 |
| time_of_day | 0.126 | 0.083 | 0.180 | 0.054 | 0.145 | 0.069 | 0.190 | 0.005 | 0.137 | 0.007 | 0.010 | 0.000 | 0.042 | 0.028 | 0.122 | 0.154 | 0.049 | 1.000 | 0.089 | 0.042 | 0.021 | 0.029 | 0.002 |
| title | 0.222 | 0.101 | 0.121 | 0.079 | 0.245 | 0.050 | 0.189 | 0.000 | 0.034 | 0.035 | 0.021 | 0.000 | 0.072 | 0.044 | 0.048 | 0.215 | 0.442 | 0.089 | 1.000 | 0.083 | 0.071 | 0.020 | -0.012 |
| total_cxl_appointments_before_appointment | -0.255 | 0.279 | -0.048 | 0.278 | 0.123 | 0.028 | 0.110 | -0.005 | 0.020 | 0.014 | 0.012 | -0.001 | -0.139 | 0.080 | -0.055 | 0.071 | -0.069 | 0.042 | 0.083 | 1.000 | 0.570 | 0.192 | 0.020 |
| total_good_appointments_before_appointment | -0.197 | 0.368 | 0.064 | 0.041 | 0.331 | 0.058 | 0.191 | -0.005 | 0.038 | 0.020 | -0.017 | -0.002 | 0.023 | 0.096 | -0.035 | 0.106 | 0.003 | 0.021 | 0.071 | 0.570 | 1.000 | 0.252 | -0.015 |
| total_open_invoices_before_appointemnt | -0.095 | 0.261 | 0.080 | 0.026 | 0.128 | 0.005 | 0.280 | 0.008 | 0.006 | 0.029 | -0.009 | -0.001 | 0.048 | -0.012 | -0.027 | 0.031 | 0.067 | 0.029 | 0.020 | 0.192 | 0.252 | 1.000 | -0.017 |
| week_of_year | -0.009 | -0.017 | -0.036 | 0.004 | -0.078 | -0.017 | -0.023 | 0.050 | -0.017 | -0.002 | 0.308 | 0.035 | -0.033 | -0.065 | 0.023 | -0.021 | -0.011 | 0.002 | -0.012 | 0.020 | -0.015 | -0.017 | 1.000 |
| case_linked | case_type | total_open_invoices_before_appointemnt | total_good_appointments_before_appointment | total_cxl_appointments_before_appointment | patient_status | patient_type | time_of_day | month_period | day_of_week | month_of_year | day_of_month | week_of_year | appointment_status | next_appointment_time | notice | cancelled_at | appointment_type | billable_item | category | cancelled | missed | appointment_start_time | business_name | customer_type | title | state | date_of_birth | sex | post_code | city | occupation | referred | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 11 | No | NaN | 0 | 0 | 0 | Not Yet Actioned | New To Clinic | Early Morning | Mid month | Friday | July | 17.0 | 29.0 | Not Rebooked | NaN | 12.73 | 2020-07-16 08:36:13+00 | ✅20 Minute Follow Up Consult | PhysioCall - 20 Minute Follow Up Consult (Pre-paid) | A | Pre Pay Online & Save ✅ | Yes | No | 2020-07-16 21:20:00+00 | PhysioCall Gladstone | Staff | Mr | QLD | 1984-02-03 | Male | 4680.0 | South Gladstone | Physio | Yes |
| 1 | 11 | No | NaN | 0 | 0 | 0 | Not Yet Actioned | Recurring | Late Afternoon | Mid month | Thursday | August | 13.0 | 33.0 | Not Rebooked | NaN | 0.00 | NaN | ✅20 Minute Follow Up Consult | PhysioCall - 20 Minute Follow Up Consult (Pre-paid) | A | Pre Pay Online & Save ✅ | No | No | 2020-08-13 06:00:00+00 | PhysioCall Gladstone | NaN | NaN | NaN | 1997-01-30 | NaN | NaN | NaN | NaN | No |
| 2 | 11 | No | NaN | 0 | 1 | 0 | Not Yet Actioned | Recurring | Late Morning | Mid month | Thursday | August | 20.0 | 34.0 | Not Rebooked | NaN | 0.00 | NaN | ✅20 Minute Follow Up Consult | PhysioCall - 20 Minute Follow Up Consult (Pre-paid) | A | Pre Pay Online & Save ✅ | No | No | 2020-08-20 01:20:00+00 | PhysioCall Gladstone | NaN | NaN | NaN | 1997-01-30 | NaN | NaN | NaN | NaN | No |
| 3 | 11 | No | NaN | 0 | 2 | 0 | Not Yet Actioned | Recurring | Late Morning | Mid month | Friday | September | 18.0 | 38.0 | Not Rebooked | NaN | 0.00 | NaN | ✅20 Minute Follow Up Consult | PhysioCall - 20 Minute Follow Up Consult (Pre-paid) | A | Pre Pay Online & Save ✅ | No | No | 2020-09-17 23:50:00+00 | PhysioCall Gladstone | NaN | NaN | NaN | 1997-01-30 | NaN | NaN | NaN | NaN | No |
| 4 | 11 | No | NaN | 0 | 0 | 0 | Not Yet Actioned | New To Clinic | Early Morning | End month | Monday | September | 21.0 | 39.0 | Not Rebooked | NaN | 0.00 | NaN | ✅20 Minute Follow Up Consult | PhysioCall - 20 Minute Follow Up Consult (Pre-paid) | A | Pre Pay Online & Save ✅ | No | No | 2020-09-20 22:20:00+00 | PhysioCall Gladstone | NaN | NaN | NaN | 1980-02-03 | NaN | NaN | NaN | NaN | No |
| 5 | 11 | No | NaN | 0 | 0 | 0 | Not Yet Actioned | Recurring | Late Afternoon | Mid month | Tuesday | October | 20.0 | 43.0 | Not Rebooked | NaN | 0.00 | NaN | ✅40 Minute Follow Up Consult | NaN | 1. PhysioCall - Pre Pay Online & Save ✅ | No | No | 2020-10-20 05:10:00+00 | PhysioCall Gladstone | NaN | Mr | QLD | 1977-06-30 | NaN | 4680.0 | Clinton | Remedial massage therapist | Yes |
| 6 | 11 | No | NaN | 0 | 0 | 0 | Not Yet Actioned | new injury/issue | Evening | Mid month | Sunday | October | 18.0 | 42.0 | Not Rebooked | NaN | 0.00 | NaN | ✅60 Minute - Initial Consult Massage | NaN | 1. Gladstone Massage - Prepay Online & Save ✅ | No | No | 2020-10-18 10:30:00+00 | Gladstone Massage | NaN | NaN | NaN | 1988-07-09 | NaN | NaN | NaN | NaN | No |
| 7 | 11 | Yes | Unlimited | 0 | 0 | 0 | Not Yet Actioned | Recurring | Late Morning | Mid month | Monday | October | 19.0 | 43.0 | Not Rebooked | NaN | 0.00 | NaN | 2. 20 Minute Follow Up Consult | PhysioCall - 20 Minute Follow Up Consult | A | Physiotherapy Treatment ❤️🩹 (in clinic) | No | No | 2020-10-19 00:40:00+00 | PhysioCall Gladstone | NaN | NaN | NaN | 1979-09-18 | NaN | NaN | NaN | NaN | No |
| 8 | 11 | No | NaN | 0 | 0 | 0 | Not Yet Actioned | Recurring | Late Morning | Mid month | Monday | October | 19.0 | 43.0 | Not Rebooked | NaN | 0.00 | NaN | ✅20 Minute Follow Up Consult | PhysioCall - 20 Minute Follow Up Consult (Pre-paid) | A | Pre Pay Online & Save ✅ | No | No | 2020-10-19 01:00:00+00 | PhysioCall Gladstone | NaN | NaN | NaN | 1994-01-16 | NaN | NaN | NaN | NaN | No |
| 9 | 11 | Yes | Unlimited | 0 | 0 | 0 | Not Yet Actioned | Recurring | Late Morning | Mid month | Monday | October | 19.0 | 43.0 | Not Rebooked | NaN | 0.00 | NaN | 40 Minute Follow Up Consult | NaN | 2. PhysioCall - Pay In Clinic | No | No | 2020-10-19 01:20:00+00 | PhysioCall Gladstone | NaN | Miss | QLD | 1994-03-05 | NaN | 4680.0 | Gladstone | QAL Operator | Yes |
| case_linked | case_type | total_open_invoices_before_appointemnt | total_good_appointments_before_appointment | total_cxl_appointments_before_appointment | patient_status | patient_type | time_of_day | month_period | day_of_week | month_of_year | day_of_month | week_of_year | appointment_status | next_appointment_time | notice | cancelled_at | appointment_type | billable_item | category | cancelled | missed | appointment_start_time | business_name | customer_type | title | state | date_of_birth | sex | post_code | city | occupation | referred | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 142578 | 16 | Yes | Max Sessions | 0 | 11 | 3 | Therapist Follow Up | Recurring | Late Afternoon | Mid month | Saturday | July | 20.0 | 29.0 | Not Rebooked | NaN | 0.0 | NaN | ✨ Osteopathy CDM - Subsequent Consultation | Osteopathy CDM - Subsequent Consultation | CDM (Medicare / GP Referrals) | No | No | 2024-07-20 02:00:00+00 | Osteopathy | Melton | NaN | NaN | NaN | 1994-04-07 | NaN | NaN | NaN | Administration | No |
| 142579 | 16 | No | NaN | 0 | 2 | 1 | Patient Stopped Treatment | Recurring | Late Afternoon | End month | Saturday | June | 22.0 | 25.0 | Not Rebooked | NaN | 0.0 | NaN | ✨ Osteopathy - Subsequent Consultation | Osteopathy - Subsequent Consultation | 2. Subsequent Osteopathy Consultations for Existing Patients | No | No | 2024-06-22 02:00:00+00 | Osteopathy | Melton | NaN | NaN | NaN | 1979-10-26 | NaN | NaN | NaN | NaN | No |
| 142580 | 16 | Yes | Unlimited | 0 | 16 | 1 | Has An Upcoming Booking | Recurring | Late Morning | Mid month | Wednesday | June | 19.0 | 25.0 | Rebooked | 2024-06-22 10:30:00 | 0.0 | NaN | 2. Physiotherapy WorkSafe - Subsequent Consultation | Physiotherapy WorkSafe - Subsequent Consultation | WorkSafe | No | No | 2024-06-19 00:30:00+00 | Physiotherapy | Melton | NaN | Mr | NaN | 1989-10-06 | Male | NaN | NaN | NaN | No |
| 142581 | 16 | Yes | Unlimited | 0 | 17 | 1 | Has An Upcoming Booking | Recurring | Late Morning | End month | Saturday | June | 22.0 | 25.0 | Rebooked | 2024-06-26 10:30:00 | 0.0 | NaN | 2. Physiotherapy WorkSafe - Subsequent Consultation | Physiotherapy WorkSafe - Subsequent Consultation | WorkSafe | No | No | 2024-06-22 00:30:00+00 | Physiotherapy | Melton | NaN | Mr | NaN | 1989-10-06 | Male | NaN | NaN | NaN | No |
| 142582 | 16 | Yes | Unlimited | 0 | 18 | 1 | Has An Upcoming Booking | Recurring | Late Morning | End month | Wednesday | June | 26.0 | 26.0 | Rebooked | 2024-06-29 11:00:00 | 0.0 | NaN | 2. Physiotherapy WorkSafe - Subsequent Consultation | Physiotherapy WorkSafe - Subsequent Consultation | WorkSafe | No | No | 2024-06-26 00:30:00+00 | Physiotherapy | Melton | NaN | Mr | NaN | 1989-10-06 | Male | NaN | NaN | NaN | No |
| 142583 | 16 | No | NaN | 0 | 28 | 4 | Admin Follow Up | Recurring | Late Afternoon | Mid month | Tuesday | June | 18.0 | 25.0 | Not Rebooked | NaN | 0.0 | NaN | ⭐️ Osteopathy - Subsequent Consultation With Senior Osteopath | Osteopathy - Subsequent Consultation With Senior Osteopath | 2. Subsequent Osteopathy Consultations for Existing Patients | No | No | 2024-06-18 02:00:00+00 | Osteopathy | Bacchus Marsh | NaN | NaN | NaN | 1989-02-17 | Female | NaN | NaN | Courier | No |
| 142584 | 16 | Yes | Unlimited | 0 | 19 | 1 | Has An Upcoming Booking | Recurring | Late Morning | End month | Saturday | June | 29.0 | 26.0 | Not Rebooked | NaN | 0.0 | NaN | 2. Physiotherapy WorkSafe - Subsequent Consultation | Physiotherapy WorkSafe - Subsequent Consultation | WorkSafe | No | No | 2024-06-29 01:00:00+00 | Physiotherapy | Melton | NaN | Mr | NaN | 1989-10-06 | Male | NaN | NaN | NaN | No |
| 142585 | 16 | Yes | Unlimited | 0 | 10 | 0 | Not Yet Actioned | Recurring | Late Afternoon | Mid month | Monday | June | 17.0 | 25.0 | Not Rebooked | NaN | 0.0 | NaN | ✨ Osteopathy - Subsequent Consultation | Osteopathy - Subsequent Consultation | 2. Subsequent Osteopathy Consultations for Existing Patients | No | No | 2024-06-17 05:15:00+00 | Osteopathy | Bacchus Marsh | NaN | Mrs | VIC | 1963-12-18 | Female | 3340 | Bacchus Marsh | Woolworths team member | Yes |
| 142586 | 16 | No | NaN | 0 | 2 | 0 | Not Yet Actioned | Recurring | Evening | Mid month | Wednesday | June | 12.0 | 24.0 | Not Rebooked | NaN | 0.0 | NaN | ⭐️ Osteopathy - Subsequent Consultation With Senior Osteopath | Osteopathy - Subsequent Consultation With Senior Osteopath | 2. Subsequent Osteopathy Consultations for Existing Patients | No | No | 2024-06-12 09:30:00+00 | Osteopathy | Bacchus Marsh | NaN | NaN | NaN | 1968-05-28 | NaN | NaN | NaN | NaN | No |
| 142587 | 16 | Yes | Unlimited | 0 | 17 | 4 | Therapist Follow Up | Recurring | Late Afternoon | Mid month | Wednesday | June | 19.0 | 25.0 | Not Rebooked | NaN | 0.0 | NaN | ⭐️ Osteopathy - Subsequent Consultation With Senior Osteopath | Osteopathy - Subsequent Consultation With Senior Osteopath | 2. Subsequent Osteopathy Consultations for Existing Patients | No | No | 2024-06-19 05:00:00+00 | Osteopathy | Melton | NDIS | NaN | VIc | 1955-11-08 | Female | 3338 | Melton South | Self Employed | No |
Most frequently occurring
| case_linked | case_type | total_open_invoices_before_appointemnt | total_good_appointments_before_appointment | total_cxl_appointments_before_appointment | patient_status | patient_type | time_of_day | month_period | day_of_week | month_of_year | day_of_month | week_of_year | appointment_status | next_appointment_time | notice | cancelled_at | appointment_type | billable_item | category | cancelled | missed | appointment_start_time | business_name | customer_type | title | state | date_of_birth | sex | city | occupation | referred | # duplicates | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 13 | No | NaN | 0 | 0 | 2 | Not Yet Actioned | New To Clinic | Late Afternoon | End month | Monday | May | 21.0 | 21.0 | Not Rebooked | NaN | -25905.13 | 2021-05-04 13:07:52+00 | Initial Consultation week day | Initial Consultation week day | NaN | Yes | No | 2018-05-21 04:00:00+00 | All Sorted Physiotherapy | NaN | NaN | NaN | NaN | Male | CALLIOPE | NaN | No | 2 |
| 1 | 13 | No | NaN | 0 | 0 | 5 | Not Yet Actioned | New To Clinic | Late Afternoon | Mid month | Thursday | June | 14.0 | 24.0 | Not Rebooked | NaN | -25331.13 | 2021-05-04 13:07:47+00 | Initial Consultation week day | Initial Consultation week day | NaN | Yes | No | 2018-06-14 02:00:00+00 | All Sorted Physiotherapy | NaN | NaN | NaN | 1984-09-28 | Female | GLADSTONE | NaN | No | 2 |
| 2 | 13 | No | NaN | 0 | 0 | 13 | Not Yet Actioned | New To Clinic | Late Morning | End month | Thursday | May | 24.0 | 21.0 | Not Rebooked | NaN | -25835.63 | 2021-05-04 13:07:51+00 | Initial Consultation week day | Initial Consultation week day | NaN | Yes | No | 2018-05-24 01:30:00+00 | All Sorted Physiotherapy | NaN | Ms | NaN | 1991-09-19 | Female | GLADSTONE | NaN | No | 2 |
| 3 | 13 | No | NaN | 0 | 13 | 6 | Not Yet Actioned | Recurring | Late Afternoon | Mid month | Thursday | June | 14.0 | 24.0 | Not Rebooked | NaN | -25327.63 | 2021-05-04 13:07:46+00 | Subsequent Consultation week day | Subsequent Consultation week day | NaN | Yes | No | 2018-06-14 05:30:00+00 | All Sorted Physiotherapy | NaN | Mr | NaN | 1956-10-10 | Male | GLADSTONE | NaN | No | 2 |
| 4 | 13 | No | NaN | 0 | 17 | 4 | Not Yet Actioned | Recurring | Late Morning | Early month | Thursday | July | 5.0 | 27.0 | Not Rebooked | NaN | -24830.13 | 2021-05-04 13:07:42+00 | Subsequent Consultation week day | Subsequent Consultation week day | NaN | Yes | No | 2018-07-04 23:00:00+00 | All Sorted Physiotherapy | NaN | Ms | NaN | 1997-01-16 | Female | GLADSTONE | NaN | No | 2 |
| 5 | 16 | No | NaN | 0 | 0 | 0 | Not Yet Actioned | New To Clinic | Late Morning | End month | Friday | April | 21.0 | 16.0 | Not Rebooked | NaN | 0.00 | NaN | ⚡️Osteopathy - Subsequent Consultation with Supervising Clinician | Osteopathy - Subsequent Consultation with Supervising Clinician | 2. Subsequent Osteopathy Consultations for Existing Patients | No | No | 2023-04-20 23:00:00+00 | ⬅️ Front Desk Migration | NaN | NaN | NaN | 1958-06-24 | NaN | NaN | Barista | No | 2 |
| 6 | 16 | No | NaN | 0 | 0 | 0 | Not Yet Actioned | New To Clinic | Late Morning | End month | Friday | July | 21.0 | 29.0 | Not Rebooked | NaN | 0.00 | NaN | ⚡️Osteopathy - Subsequent Consultation with Supervising Clinician | Osteopathy - Subsequent Consultation with Supervising Clinician | 2. Subsequent Osteopathy Consultations for Existing Patients | No | No | 2023-07-20 23:30:00+00 | ⬅️ Front Desk Migration | NaN | NaN | NaN | 1971-03-12 | NaN | NaN | NaN | No | 2 |
| 7 | 16 | No | NaN | 0 | 0 | 0 | Not Yet Actioned | New To Clinic | Late Morning | End month | Friday | March | 24.0 | 12.0 | Not Rebooked | NaN | 0.00 | NaN | ⚡️Osteopathy - Subsequent Consultation with Supervising Clinician | Osteopathy - Subsequent Consultation with Supervising Clinician | 2. Subsequent Osteopathy Consultations for Existing Patients | No | No | 2023-03-23 23:00:00+00 | ⬅️ Front Desk Migration | NaN | NaN | NaN | 1994-04-16 | NaN | NaN | Retail Manager | No | 2 |
| 8 | 16 | No | NaN | 0 | 0 | 0 | Not Yet Actioned | New To Clinic | Late Morning | End month | Wednesday | February | 22.0 | 8.0 | Not Rebooked | NaN | 0.00 | NaN | ⚡️Osteopathy - Subsequent Consultation with Supervising Clinician | Osteopathy - Subsequent Consultation with Supervising Clinician | 2. Subsequent Osteopathy Consultations for Existing Patients | No | No | 2023-02-21 23:00:00+00 | ⬅️ Front Desk Migration | NaN | NaN | NaN | 1944-12-16 | NaN | NaN | Retired | No | 2 |
| 9 | 16 | No | NaN | 0 | 0 | 0 | Not Yet Actioned | New To Clinic | Late Morning | Mid month | Friday | July | 14.0 | 28.0 | Not Rebooked | NaN | 0.00 | NaN | ⚡️Osteopathy CDM - Subsequent Consultation with Supervising Clinician | Osteopathy CDM - Subsequent Consultation with Supervising Clinician | CDM (Medicare / GP Referrals) | No | No | 2023-07-13 23:30:00+00 | ⬅️ Front Desk Migration | NaN | NaN | NaN | 1960-01-17 | NaN | NaN | Cleaner | No | 2 |